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
MFelix's avatar
MFelix
Super User
5 years ago

Hi jct999 ,

 

You need to create a custom function and then when you expand the final result you get the table you need.

 

Can you please share a mockup data or sample of your PBIX file and expected result. You can use a onedrive, google drive, we transfer or similar link to upload your files.


  • 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.

    • MFelix's avatar
      MFelix
      Super User
      5 years ago

      Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

      If the information is sensitive please share it trough private message.