Forum Discussion

HasanK's avatar
HasanK
Helper I
6 years ago
Solved

Column Matches

Hi, I would like to learn wherher there is a solution; there are two or more different reports which have similar data but under different column names such one report contains Date, Customer Name, ...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi HasanK 

     

    Sure, its because I forgot to mention a rather imported thing, the function is using one of the columns in the columns mapping table, to fix the error you can rename the column names or adjust the function.

     

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi HasanK 

 

Please see the attached with a solution, it can be set as per below.

You can create an extra table with all the possible column names and translations, in the attached example table name is columnsMapping.

Create a function that will check names in the given file against your mapping table and rename the column accordingly, in my example the function name is renameColumns and it's applied as a step in the data table, but if you work with folders that could be adjusted to a column and invoked as "Invoke Custom Function" that way you could expand all columns together without extra step to append.

 

let me know if anything isn't clear.

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

 

HasanK's avatar
HasanK
Helper I
6 years ago

Hi Mariusz ,

Thanks for sharing, this is my first experience, I am rookie... I have got an error, 

An error occurred in the ‘’ query. Expression.Error: The field 'find' of the record wasn't found.
Details:
Find=Disty
Replace=01_Disty

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi HasanK 

     

    Sure, its because I forgot to mention a rather imported thing, the function is using one of the columns in the columns mapping table, to fix the error you can rename the column names or adjust the function.

     

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

    • HasanK's avatar
      HasanK
      Helper I
      6 years ago

      Hi Mariusz,

      It was case sensitive, thank you very much...