Forum Discussion
Can not replace Table with in column--- need help for project
i connceted to sharepoint list, tried to import along with data versions( share point version history ) so that i can see past modified data. when I import and kept expanding properties and...
above solution reducing the record count,
I got soulution using = Table.AddColumn(#"Removed Other Columns", "GetValue2",each if Value.Is([V.properties.field_x005f_18], type table) then null else [V.properties.field_x005f_18])
= Table.AddColumn(#"source/before step, "column-name",each if Value.Is([V.properties.field_x005f_18], type table) then null else [V.properties.field_x005f_18])
jaipal
Resolver III
Resolver IIIAnonymous Click on the Button
Text Filters --> Does Not Equal...
play with it.