You should be able to use an AttributeExploder here. If you can upload the 4 lines of the csv file you have posted i can create an example
Hi ebygomm,
Attached is the incoming CSV file.
Thanks for your quick reply.
Lowell
This should get you most of the way there
A more elegant solution than the one I was envisioning - thank you!
One final question - What transformer can I use to update the values of TagName in the file? For example, I need to change spCond to LLSCADA.LL_EX02_SPCOND_US_CM.F_CV, PH to LLSCADA.LL_EX02_PH.F_CV, etc...
A more elegant solution than the one I was envisioning - thank you!
One final question - What transformer can I use to update the values of TagName in the file? For example, I need to change spCond to LLSCADA.LL_EX02_SPCOND_US_CM.F_CV, PH to LLSCADA.LL_EX02_PH.F_CV, etc...
You could use an attribute value mapper to change these values. If you have an excel or csv file with the existing value and the one you want to transform to you should be able to import into the transformer