Forum Discussion

jct999's avatar
jct999
Advocate II
5 years ago

Iterator over a table.

Hi, I have a table with 4 columns and a few rows. I want to iterate over this table and pass each row to a personal function. This personal function simply creates a table using the parameters ...
Need Help
jct999's avatar
jct999
Advocate II
5 years ago

Thanks for your answer but it is not clear for me.


The table I want to iterate has 4 columns :
- FILE_NAME
- YEAR
- MONTH
- AUTHOR_ID


My personnal function just loads the file FILE_NAME in a table and add 3 columns to this table : YEAR, MONTH dans AUTHOD_ID.
Then, at the end, I want to combine all the table loaded in one table.


I can't send you my model nor PBix file... Could you show me an exemple.

Regards

 

 

jct999's avatar
jct999
Advocate II
5 years ago

Thanks for your reply, but it is not clear to me.

The table I want to iterate has 4 columns:
- FILE_NAME
- Year
- MONTH
- AUTHOR_ID

My personal function just loads the FILE_NAME file into a table and add 3 columns to this table: YEAR, MONTH dans AUTHOD_ID.
Then at the end I want to merge all the loaded table into one table.

I can't send you my model or the PBix file ... Could you show me an example.