Column Concatenation

[owneyjs15]

I'm trying to concatenate a column value to a string. The step #"Extracted Text Between Deliminaters" has a column Web Color and i want to reference that in the next step where the underline is. What is the correct syntax for referencing the current column value?

#"Extracted Text Between Delimiters" = Table.TransformColumns(#"Extracted Table From Html", {{"Web Color", each Text.BetweenDelimiters(_, "Color=", "&"), type text}}),
#"Loaded Style Number" = Web.BrowserContents("https://www.brooksbrothers.com/on/demandware.store/Sites-brooksbrothers-Site/default/Product-Variation?pid=" & item & "&dwvar_" & item & "_Color=" & ______________________ & "&format=ajax"),

[Jimmy801 · Accepted solution]

Hello @owneyjs15 

sorry, I don't get the point. Your Web.Contents-function needs a scalar value and i suppose your column contains multiple rows. So should these rows somehow put together, or what is the goal? I think your real need is to invoke web.contents for every row in your table, and use the column Web Color as parameter. Is this what you need? Then your code should look like this (not tested)

#"Extracted Text Between Delimiters" = Table.TransformColumns(#"Extracted Table From Html", {{"Web Color", each Text.BetweenDelimiters(_, "Color=", "&"), type text}}),
#"Loaded Style Number" = Table.AddColumn(#"Extracted Text Between Delimiters", "Style Number", each Web.BrowserContents("https://www.brooksbrothers.com/on/demandware.store/Sites-brooksbrothers-Site/default/Product-Variation?pid=" & item & "&dwvar_" & item & "_Color=" & [Web Color] & "&format=ajax"),

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