Use Of Excel File on DI (request)

building reports desktopintelligence
1

Good afternoon,

I’m working with DI and I have a problem using an imported Excel file:

Like you can see here I have 2 columns of data in this Excel file.
What I’m trying to do is to get DI to get me the data in the column “PointsSaisieBD” according to the value of “CodeUETbd” that the user insert.

To sum up: The User inputs a value, then the program searches in the Excel that value in the column “CodeUETbd” and send back the correct value from the column “PointsSaisieBD”

So far when I try it sends back all the values of the column “PointsSaisieBD”
Can you please help me ?

Thank you for reading

redkof (BOB member since 2016-05-27)

2

Have you tried using the result of another query functionality?

Create a query where the user is prompted for a CodeUETbd value.
Have this query simply return CodeUETbd.

Then have a second query return PointsSaisieBD where CodeUETbd is the result of the first query.