Data Preparation for AI Builder Sample

(0) Share

Report

Posted on by zdzunic

Hi,

please can somebody test data preparation for this AI Builder sample for Prediction model and

https://docs.microsoft.com/en-us/ai-builder/prediction-data-prep

It seems that doesn't work any more, it is'n possible any more to import rows with target value null (Revenue (Label)).

Thanks!

Categories:

AI Builder

All responses (4)

Answers (0)

Sort by

Norah Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

hi @zdzunic
Could you tell me at which step in the doc you see the error of not able to import null value? Did you map the columns correctly when importing? Because I just tried to follow instruction in the doc above to import data, and it worked for me.
zdzunic 46 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Nora,
Thank you for your answer. I got no error, but the "Ravenue" field get "No" value.
Could you tell me which data type did you use for "Ravenue" field, or have you made other transformation in table OnlineShopperIntention bevor the import ?
Thanks!
Norah Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

hi I'm sorry to hear the issue.

Pasting the schema I'm using, the Revenue field is a Yes/No field.
zdzunic 46 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Norah ,
I checked import once more but i got again the same results ( null values in .csv file for Revenue field are after import "No")
Here are the steps what i done:
1. Import solution AIBuilderOnlineShopperIntention_1_0_0_0.zip (which i downloaded from git)
2.Check the table definition (aib_onlineshopperintention) in dataverse after importing solution (attachment 1)
3. "Revenue" field is "Yes/No" with default Value "No" but "optional"
4. Get data (https://raw.githubusercontent.com/microsoft/PowerApps-Samples/master/ai-builder/aib_onlineshopperintention.csv
5.From import, customer1 to customer 29 have aib_Revenue field "null" (attachment 2)
6. Field aib_Revenue is {"aib_Revenue", type logical}})
7. Load .csv file into existing table (aib_onlineshopperintention)
8. Auto map
9. Check the values for aib_Revenue field in table (attachment 3
Did you make the same procedure or there are some differences?
I am sure that was working earlier