Delimited File Merge data from group file to Account file

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

Hi all

I have two requirements for delimited files

  1. The account csv file contains account data but missing group information, for example, groupName. The group file contains group information but it also contains userName, this needs to be removed from here and the account file needs to be updated with groupName by matching it to the userName. I am thinking of using Pre-Iterate rule but not sure how to do that

  2. Both the account and group csv files contains extra header and footer lines which should not be used in aggregation and I need to clean those lines, should I use BuildMap or Pre-Iterate rule ?

Let me know if you can help in these usecases

2

Since you want to get data from group file and append to account csv file you should use the pre-iterate rule for your requirement. You can remove header and footer lines in pre-iterate rule itself.

In case you are looking for any samples this should be helpful.

3

Thank you @SanjeevIAM