Forum Discussion
Sharing Variables between two sources
Dear all,
I have the following code:
let
Source1 = OVERALL_DISTRIBUTION,
#"Filtered Rows" = Table.SelectRows(Source1, each ([Integrated_Check_Valve] = "Integrated Check Valve NO") and ([Connection_Type_Front_Port] = "Female Thread") and ([Voltage] = "24VDC") and ([Valve_Function] = "Collector") and ([Sealing_Material] = "FPM") and ([Pipe_Size_Front_Port] = "1/2 inch")),
Source2 = Component_List,
Name_Column = Source2 [Name],
Breakdown_Numbers = List.Count (Name_Column),
New = Table.AddColumn(#"Filtered Rows", "List", each {1..[Breakdown_Numbers]})
in New
As you can see, my target is to use the variable Breakdown_Numbers (related to the source 2) to add a column List in the Source1.
However I got the following error:
Expression.Error: The field 'Breakdown_Numbers' of the record wasn't found
I think this is something related to the variable delcaration, but I am not very familiar with the topic.
Hoping you can support.
Thanks.
Hi Mic1979
Remove the square brackets around
Breakdown_Numbersin theNewstep:New = Table.AddColumn(#"Filtered Rows", "List", each {1 .. Breakdown_Numbers})A reference to another variable within a
letexpression doesn't require square brackets.With the square brackets,
[Breakdown_Numbers]was attempting to access a field namedBreakdown_Numberswithin the rows of#"Filtered Rows", which would work only if#"Filtered Rows"contained a column namedBreakdown_Numbers.See here:
2 Replies
- OwenAugerSuper User
Hi Mic1979
Remove the square brackets around
Breakdown_Numbersin theNewstep:New = Table.AddColumn(#"Filtered Rows", "List", each {1 .. Breakdown_Numbers})A reference to another variable within a
letexpression doesn't require square brackets.With the square brackets,
[Breakdown_Numbers]was attempting to access a field namedBreakdown_Numberswithin the rows of#"Filtered Rows", which would work only if#"Filtered Rows"contained a column namedBreakdown_Numbers.See here:
- Mic1979Post Partisan
PERFECT!!
Thanks