Conditionally Appending Columns using Data from Table

Ignition
, ,
1

image
image1292×443 43.7 KB

I have a query that grabs information from the database. On the right of the picture, you can see a two of the rows from the Database. For future data manipulation, I would like to use a transform script to append Columns called Source 1/Source 2 if they find Sources that have the same Ingredient Code.

Is there a way to do this?

2

You could use a crosstab query. Or you could make a new table and append the values you want to the new table selected from each source based off your desired criteria.

3

That would normally be done in the DB using a JOIN to a table that describes the sources.