This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I can't seem to find a solution anywhere but here's what I'm after
I have ~3 million records in a yxdb table that I've created and now I'm trying to create an app for the business that allows a user to input and return the fields for 1, many, or all primary key values (let's call it item_no). Essentially i need the business to be able to paste in a list of values and return all relevant information from my 3million record table.
I've tried several ways to do this via in statements/filters, creating new data inputs and keep coming up empty.
I know that this is a nasty way round, but you could do this very quickly by letting them put the relevant values in a spreadsheet. The benefit of this is that time-to-value is pretty much zero (you could do this in seconds)
Cleaner would be to create a simple macro that gives them a plain text input box which they can ; delimit the primary keys, and then pump this out to a YXDB once you've cleaned it up, and then use that to join?
By separating this out into a specific macro, you can do all the error checking and control the complexity possibly a little easier?
I recreated your worflow, but instead of having that Browse tool, I put an output tool since i would ultimately like it to render to a nice formatted table... However, when I do that, it only outputs the first record I entered. Even if I use the semicolon to separate my records, it only outputs the first record... I modified your workflow by replacing the browse tool with an output tool, and it looks like you run into the same issue. Any idea how to fix that so I can output to an excel file with the multiple records that my user specifies?