You are not logged in.
I am using TIS Pro 4.2.3 version. I have a requirement of splitting columns based on Headers from a CSV file into multiple data flows and update tables.
Say for ex, my CSV file is as below:
Now based on the header 'DM' or 'BIO' I have to split into two data flows and update DM_Table and BIO_Table accordingly.
My columns can increase or decrease. So the number of data flow splits also can increase or decrease.
Can anyone throw some light on this topic?
Thanks in advance,
The only way I can think about is using Dynamic Schemas.
Basically the Dynamic Schemas are going to allow you to get data from your csv file, without defining a schema. Then you can use specific functions related to the Dynamic Schema to get the column name, and send the data to a flow or another based on that.
Thanks a lot for the reply. Helped a lot.
Now I am stuck up with another problem. I am not able to delete dynamic elements using the function, removeDynamicElement(String columnName).
For the first row input, header and values are deleted but for the second or third rows values are not getting deleted.
I have to delete second column, i.e. Col2, but using removeDynamicElement(Col2) function only "Col2" and Value2 are getting deleted. "Value6" and "Value10" remain the same.
Is this a bug or is there an issue with my logic??