
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
script load where exist
Hey folks,
I am trying to load a data reduced table on chosen data.
In my example it is not only one record but several so I tried to load them with where and * statement.
Example:
Dimension:
date
eventrow - (filled with Bread 2017, Croissant 2018, Croissant 2015, Butter Croissant 2016, 2018 Bread, 2019 Butter Bread)
event
I want only data with bread in the name be loaded from the dimension eventrow . So I tried to load my data like this:
Breadaddict:
Load
date,
eventrow ,
event
FROM [DATA XY]
(qvd)
where eventrow = '*Bread*'
;
If I want only one data set to be loaded I can do it with "where eventrow = 'Bread 2017'" e.g. but what do I have to do to have all the data with bread?
Thanks for your help!
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
where wildmatch(eventrow, '*Bread*'):
and wildmatch is not case sensitive...


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
where eventrow like '*Bread*'
-Rob


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
where wildmatch(eventrow, '*Bread*'):
and wildmatch is not case sensitive...
