Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello to all community!
My questions are quite easy but it is quite important for me and for newbee guys...So your replies quite useful for all starter users..
My problems are adding condition while loading data from source...I dont wanna go to database to add condition and limit the size of data...I need to learn 2 issues which are quite important when we make reports..
First one;
I would like to use only column A and I need only X and Y from column while loading data..How can I write a sciprt when I reload it whole data and select those conditions? (I have tried where condition but dont know why it doesnt fix it up )
Second one:
How can I select date range from DATE column while loading data?
For example I would like to see only date from 01-01-2014 and 05-01-2014?
I have uploaded a test qwv and if you reply me in a short time I really would be appreciated in you..
Thanks for replying me...
Hi Alessandro;
what about if the data is like below and If I want to pick only Y from Column A;
COLUMN A | COLUMN B | DATE |
X,Y | 5 | 1/1/2014 |
Y,Z | 10 | 2/1/2014 |
Z,A | 15 | 3/1/2014 |
A,Y | 20 | 4/1/2014 |
B,Y | 25 | 5/1/2014 |
C,X | 30 | 6/1/2014 |
M,Y | 35 | 7/1/2014 |
N,Y | 40 | 8/1/2014 |
K,Y | 45 | 9/1/2014 |
Hi ATACAN,
Let try WildMatch() not Match()
LOAD [COLUMN A],
[COLUMN B],
DATE
FROM
(ooxml, embedded labels, table is Sheet1)
Where WildMatch([COLUMN A],'*Y*');
Regards,
Sokkorn
Yep! Now you got the result what I want....thnx a lot man!
Welcome ATACAN