I am following this guide and I successfully did the first 5 or so minutes and created a mapping table. I have three files, a blank template, and two files with dummy data.
Template
https://imgur.com/RfQ9joM
File 1
File 2
I want to append the contents of file 1 and 2, to the blank template. When i try to transform the sample file I used this formula.
= Table.TransformColumnNames(Table3_Table, each
List.Accumulate(Table.ToRecords(Table23),_,
(state, Current)=> Text.Replace(Text.Upper(state),current
[BEFORE], current [AFTER]) ))
Which presents this error:
Expression.Error: The name 'Table3_Table' wasn't recognized. Make sure it's spelled correctly.
Here is the source part of the transformation
Top is the header table but without any content
Table3 is the template but without any info so just headings of the final doc
Table 23 is the mapping table mentioned earlier in the vid.
What do i do?
Template
https://imgur.com/RfQ9joM
File 1
File 2
I want to append the contents of file 1 and 2, to the blank template. When i try to transform the sample file I used this formula.
= Table.TransformColumnNames(Table3_Table, each
List.Accumulate(Table.ToRecords(Table23),_,
(state, Current)=> Text.Replace(Text.Upper(state),current
[BEFORE], current [AFTER]) ))
Which presents this error:
Expression.Error: The name 'Table3_Table' wasn't recognized. Make sure it's spelled correctly.
Here is the source part of the transformation
Top is the header table but without any content
Table3 is the template but without any info so just headings of the final doc
Table 23 is the mapping table mentioned earlier in the vid.
What do i do?