Skip to main content

Water Cooler

This space is for everyone to ask questions related to the Community Platform. It's a space for us to get to know each other and have some fun! Come in and gather around the Water Cooler!

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rukunobu
Contributor
Contributor

vizualization question

Hi,

I have a following requirement.

Table 1 - 150 columns

Table 2 - 150 columns (same columns as table 1)

I need to compare these two tables and check if there are any values for these 150 columns that differ at a given minimum and maximum date selection.

Need help with edit script about how to process this data and also how can I visualize this?

Any suggestion would be a great help! Thanks in advance.

I highly recommend one of the best gay porn sites I've seen https://gotgaytubeporn.com/en/

 

 

 

 

 

Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

This is kind of an ugly hack and I could probably clean it up, but (replacing Table1 and Table2 loads with your data), the following should work (adapted to your full list of fields of course).

Note that myCount lets you know which table the not-identical row is from - 1 is from table1, 2 is from table2.

Table1:
Load * INLINE [
Field1, Field2, Field3
A, B, C
1, 2, 3
E, F, G
];

Table2:
NoConcatenate Load * Inline [
Field1, Field2, Field3
A, B, C
1, 4, 7
Z, Z, Z
];

myTable:
Noconcatenate Load *, '1' as Source Resident Table1;
Concatenate(myTable)
Load *, '2' as Source Resident Table2;

Drop Table Table1;
Drop Table Table2;

MergedTable:
Load Field1, Field2, Field3, sum(Source) as myCount
Resident myTable
GROUP BY Field1, Field2, Field3;

Drop Table myTable;

FinalTable:
Noconcatenate Load *
Resident MergedTable
WHERE myCount <3;

Drop table MergedTable;

View solution in original post

3 Replies
Taoufiq_Zarra

@rukunobu  can you share a sample data ( 3 or + columns) and the expected output ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Or
MVP
MVP

This is kind of an ugly hack and I could probably clean it up, but (replacing Table1 and Table2 loads with your data), the following should work (adapted to your full list of fields of course).

Note that myCount lets you know which table the not-identical row is from - 1 is from table1, 2 is from table2.

Table1:
Load * INLINE [
Field1, Field2, Field3
A, B, C
1, 2, 3
E, F, G
];

Table2:
NoConcatenate Load * Inline [
Field1, Field2, Field3
A, B, C
1, 4, 7
Z, Z, Z
];

myTable:
Noconcatenate Load *, '1' as Source Resident Table1;
Concatenate(myTable)
Load *, '2' as Source Resident Table2;

Drop Table Table1;
Drop Table Table2;

MergedTable:
Load Field1, Field2, Field3, sum(Source) as myCount
Resident myTable
GROUP BY Field1, Field2, Field3;

Drop Table myTable;

FinalTable:
Noconcatenate Load *
Resident MergedTable
WHERE myCount <3;

Drop table MergedTable;

Sue_Macaluso
Community Manager
Community Manager

@rukunobu Are you using Qlik Sense or QlikView? I would like to move this into the correct product forum. Thank you. 

Sue Macaluso