Forum Discussion
Add column to Merged Query when sub query contains text
hi ImaKickUrBut ,
output :
solution is attached. This solution ignores any case sensitivity. Moreover, adding more items in the list where "butter" is hardcoded in the "HasButter" step, would check for any another item added and would mark true.
I believe p45cal , solution will also work. This is an extension with a bit more functinality, in my opinion.
If this doesn't resolve the issue, kindly expand on the required output.
Hi,
Try to follow these steps:
1 - After you merge the tables, instead of expand the merge, choose agregate as shown bellow, and then select the field you want to count, in your case the [recipe id] column:
2. Your result now should look like this:
3. Now add a custom column with this code and click ok:
if [#"Count of Item No."] > 1 then true else false4- Now your table should look like this:
5. now you can remove the count column:
6. Your final result, should look like this:
NOTE: Dont forget to double check the columns names and data type of the columns.
Hi,
Try to follow these steps:
1 - After you merge the tables, instead of expand the merge, choose agregate as shown bellow, and then select the field you want to count, in your case the [recipe id] column:
2. Your result now should look like this:
3. Now add a custom column with this code and click ok:
if [#"Count of Item No."] > 1 then true else false
4- Now your table should look like this:
5. now you can remove the count column:
6. Your final result, should look like this:
NOTE: Dont forget to double check the columns names and data type of the columns.
How this has been accepted as a solution is beyond me!
As Marlon Brando might have said in Paris: Où est le beurre?
you were right to call this out. Although Bibiano_Geraldo's solution was functional, after retrying adudani 's solution, it was the better one.
