Convert Excel power query table column to string

Question

I am trying to make my power query more dynamic, currently I request my data using a stored procedure including part-no parameter that I hard-code into my query

EXEC GSCM_Staging.dbo.top_N_BOM 
    @Top_Parts = 'GL158K380G03|GL302K479G02|GL825R339G06|GL825R367G03|GL212R585G06'

I already have the individual part numbers in a list from a table in Excel

How would I go about converting this column with 4 rows into a column with a single pipe delimited row (Like the one used in my SQL query)

Found the answer here stackoverflow.com/questions/33111443/… — Henrik Poulsen
– Henrik Poulsen, Commented Aug 28, 2019 at 6:46

Rosetta · Accepted Answer · 2019-08-29 12:36:49Z

2

Fairly easy

Beginning from your Source table

first convert the table to list
```
ListOfParts = Source[TOP_PART]
```

then concatenate the list into delimited text

JoinedText = Text.Combine(ListOfParts, "|")

further modify it if required
```
PartsFilter = "'" & JoinedText "'"
```

In short

let
    Source = Table.CurrentWorkbook.....
    ListOfParts = Source[TOP_PART]
    JoinedText = Text.Combine(ListOfParts, "|")
    PartsFilter = "'" & JoinedText "'"
in PartsFilter

answered Aug 29, 2019 at 12:36

Rosetta

2,7351 gold badge17 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert Excel power query table column to string

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related