LabVIEW
Repeat same rows multiple times in a result
Solved!
Hi AB,
The result set should look like below with 5 rows
Index the rows as needed in a loop and use the autoindexed loop output…
I have tried with UNION ALL, IN Functionalities but missing something in a query.
Are you talking about LabVIEW here at all?
Could you attach your VI?
Hi AB,
maybe you should give a FULL view of your task!
So you query some "rows" (aka records) from a database. Then you want to output those "rows" somewhere in a certain order with some of the "rows" duplicated in a "random" scheme.
Atleast that's what I read from your description so far…
Where do you read from?
How do you read the "rows"?
How do you want to (re)order the rows?
Where do you want to store those "rows"?
Like udka seems to be saying, I'd also suggest getting the simplest data into LabVIEW, and then doing more complicated operations natively in LabVIEW. Although you can write obscenely clever queries (perhaps - I can't!...) in SQL, in many cases LabVIEW is more able to handle what you need (and at least for me, often in a simpler to understand (and more importantly code) way).
I have found in the past I can read multiple orders of magnitude more data out of a database and decimate it in LabVIEW than try and concoct an indexing function within the database to decimate there in the same time.
Once you know the way in which you want to duplicate data, getting LabVIEW to do it (with Insert Into Array as udka suggests, or similar) should be simple.
