Hi I am new in Clover.
I try to use it for transform a price file a file to another format and add some data for send to a ERP in a excel format.
My issues is I use Universal Data Reader with a .csv file. And I define the metadata with a file.
I try to use Reformat and Aggregate and Universal Data Writer.
But my issues in the details.
How set the metadada? Do I need define a new metadata when I Aggregate ?
Do I need to define a different paths for each transformation?
For example :
I need to classify a groups of part numbers in different brands and in that brands I need to classify in Two categories. And for that classification I need to aggregate and classifications for the ERP. and I gather all the data for write in one file.
I know sound I am clear how program that but how translate that ideas in Clover that is my issue.
Tks for you help.
I try to use it for transform a price file a file to another format and add some data for send to a ERP in a excel format.
My issues is I use Universal Data Reader with a .csv file. And I define the metadata with a file.
I try to use Reformat and Aggregate and Universal Data Writer.
But my issues in the details.
How set the metadada? Do I need define a new metadata when I Aggregate ?
Do I need to define a different paths for each transformation?
For example :
I need to classify a groups of part numbers in different brands and in that brands I need to classify in Two categories. And for that classification I need to aggregate and classifications for the ERP. and I gather all the data for write in one file.
I know sound I am clear how program that but how translate that ideas in Clover that is my issue.
Tks for you help.
-
Hello, grojas123,
Yes, you will propably need a new metadata for the edge after the Aggregate component. When you start Designer for the first time, you can see Welcome screen with examples. One of them is named Joining & Aggregating, it should be helpful for you. If you do not see Welcome screen, you can find it via Help -> Welcome.
Best regards,
Please sign in to leave a comment.
Comments 2