Good Day,
Still learning and I need help on this. THANKS A LOT IN ADVANCE
HAVE THIS
DMDLOCD6_1_2020D1_13_20D1_20_2012039GDL0.1980.2010.28412039MEX1.1811.2011.6912039MTY0.8950.911.28112039TIJ1.2761.2390.297
First Row is Headers
NEED THIS
12039GDLD6_1_20200.19812039GDLD1_13_200.20112039GDLD1_20_200.28412039MEXD6_1_20201.18112039MEXD1_13_201.20112039MEXD1_20_201.6912039MTYD6_1_20200.89512039MTYD1_13_200.9112039MTYD1_20_201.28112039TIJD6_1_20201.27612039TIJD1_13_201.23912039TIJD1_20_200.297
+37I would think an AttributeExploder would do most of what you want.
Takashi's answer in https://knowledge.safe.com/questions/65491/passing-a-table-to-the-attributeexploder-but-keepi.html is a good starting point.
@dkus2001 Are the source column names always consistent?
Hi Robotix,
Thanks for answering. Those are headers that are going to be changing because they are dates. But I am happy if I can arrive to an answer on how to do it. I have played with the exploder but to be honest after long hours I have not come to a way to do it. I am not an expert.
I would think an AttributeExploder would do most of what you want.
Takashi's answer in https://knowledge.safe.com/questions/65491/passing-a-table-to-the-attributeexploder-but-keepi.html is a good starting point.
Thank you jdh for answering. I will try to play with that.
+10@dkus2001 Are the source column names always consistent?
@dkus2001
DenormalizeExcel_Example.fmw I just had the same issue but my columns were static. Find the solution in the attached.
You would have to refresh your reader and re-select the columns but this may help you down the path. I created a simple spreadsheet with your example. Then I fed it in and selected the relevant columns in the attribute keepers.
+10@dkus2001 Are the source column names always consistent?
This may give you a better idea of how it works.
This may give you a better idea of how it works.
Robotix,
Than you SO MUCH for the time you devoted to the answer. IT IS SO VERY APPRECIATED..!! I will try I will go back. Many Many Thanks..!!
This may give you a better idea of how it works.
When I said I was going to test I meant understand. I am pretty sure that it works. You are so talented..!!
@dkus2001 Are the source column names always consistent?
Robotix
Thank you very much for your. It works perfectly as expected. Again I am very grateful for your help and time...!!!
One day I might know half of what you know..!!
:-)
+10@dkus2001 Are the source column names always consistent?
That's great! Glad I could help out.
