Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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) ?
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) ?
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
Ok wt is this issue then.
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