Crosstable if statement

[#1]

HI Experts

I have a load statement where it takes data from table a ( through SQL) and data from table b ( from Excel)

On the Dashboard I have a field in each table that I compare  AccountSQL and AccountXL

I am looking to compare these as part of the load statement , is this possible ? as they both come FROM different tables ??

Thanks

A

[Anonymous · Accepted solution]

I don't think that will be a problem. It doens't matter from how many sources you get your data.

Can you share a sample of your data from both data source (fe in 2 excel files) ?

[#3]

Hi Denis

Im actually going to repost the qury in a bit more detail ,

I havent really explained the issue correctly I think

Thanks

A

[jagannalla]

Ok wt is this issue then.

[#5]

Hi Jagan

I came up with a solution ( its hairy at best!!)

It in the post Distinct compare 2 diff tables in script

Any advice or guidance would be really appreciated

Thanks

A