How does one reference a tColumnList from the globalMap?
Hi Talend folks!
I'm using the tColumnList and it appears to insert a tables schema as a list into the GlobalMap. Works like a charm and I've included some of the GlobalMap printed out. What I can't seem to figure out is how do you reference one of these items from a list stored in the GlobalMap?
I tried accessing them as arrays, like tMysqlColumnList_2_COLUMN_NAME, but no go. Tried iterating, but it only outputs 1 row...so I'm a little confused.
Here's an example job that prints all the columns of the table.
The t*ColumnList components will execute a metadata query in the BEGIN section of the component and populate the globalMap. by using the Iterate link, we allow the component to populate the globalMap with one column per iteration.
If you need the data in a flow, you can use the tIterateToFlow component to gather up all the iterations and then output them as a flow:
Thanks for the guidance John, it was the tFlowIterate that I was missing. I'm now able to work with dynamic schemas to normalize data from a table. Still trying to figure out a few things on the output side, but I'll post my working sample back to the group to share as soon as I get a few other pieces working. Garf