Forum Discussion
power query - transform sample file issue
hi, I have a spreadsheet where i am aggregating the outputs from x number of CSVs / 'Assets' saved in a set folder directory. All CSVs are in the same format / layout so i have a 'Transform sample...
Hello AlexReed123
it's very hard to understand what exactly is going on, but I suppose that the column "scenario" is the starting column4. And with this step you are basically emptying this column
#"Replaced Value1" = Table.ReplaceValue(#"Added Index",each if [Index] <> 1 then [Column4] else null, null, Replacer.ReplaceValue,{"Column4"}),
So how you can expect that this column is containing data?
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy