Forum Discussion

Mic1979's avatar
Mic1979
Post Partisan
1 year ago
Solved

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.

2 Replies