Background colour

[Ayaanarjun-5885]

Hi,

I have combined L and J of Join tool to Union tool(#1 and #2) and then I want to color the records which are present only in L but not in J.. For example L contains 5 records and J contains 10 records when I union them I want background color for 5 records which are present in L and remaining 10should be color less in output file.. May I know How could I do it?

[binuacs · Accepted solution]

@Ayaanarjun-5885 One way of doing this with the table tool

[Christina_H]

To get colour in your output you need to use reporting tools.  See attached, I've used a row rule in the table tool to colour rows that didn't join.

[DataNath · Accepted solution]

@Ayaanarjun-5885 I've just mocked something up quickly that achieves the same scenario as you've outlined here. Here I've got 2 streams of data; one with numbers 1-10 and the other with 1-15, therefore 11-15 will not join and come out of the L anchor like in your case.

To each of the J and L output streams, I add a flag which I can then utilise later in the flow (the J anchor is the same with 'J'):

The next step is to use the Table tool within the reporting tab. Here, I can set a column rule based on a certain condition - in this case, the flag field being equal to 'L'. You'll notice here that I have unticked the [Flag] field, so that it doesn't appear in the output:

To output this with the formatting intact, we then use a Render tool and save as an Excel file (.xlsx), which gives the following result:

Hopefully this helps - if you need any further help then please do shout up.