Integrate Local and Remote Data in Einstein Analytics Prepare Your Combined Data in a Recipe - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
michele tancorramichele tancorra 

Integrate Local and Remote Data in Einstein Analytics Prepare Your Combined Data in a Recipe

Hi all,
I have a trouble with this Trailhead

Integrate Local and Remote Data in Einstein Analytics - Prepare Your Combined Data in a Recipe

When I verify my step, the system gives me this error message:

"Step not yet complete in DTC Electronics US org
We can't find the required fields in the 'North America Sales' dataset. Check the instructions and make sure that you've created the 'North America Sales' recipe correctly."


Can anyone help me please?
Can I have the list of field required?
tks

 
Best Answer chosen by michele tancorra
Hadi UppalHadi Uppal

Hey Michele, 

I had the same issue and was able to get it resoolved. You need to have the correct fields and ensure that they have the correct label as well.

Field List:
Label | API Name
1) Account Name | AccountId.Name
2) Account Country | AccountId.BillingCountry
3) Owner | OwnerId.Name
4) Stage (formed from Bucket Cluster)
5) Account City | AccountId.BillingCity
6) Account State/Province | AccountId.BillingState
7) Close Date | CloseDate
8) Name | Name
9) Type | Type
10)  Account Type | AccountId.Type
11) Lead Source | LeadSource
12) Industry | AccountId.Industry
13) Owner Title | OwnerId.Title
14) Created Date | CreatedDate
15) USD Amount | USDAmount

If you still have an issue, add in the OwnerId field. The instructions say to remove it but I had it just in case. Ensure these columns are available in the preview and selected when you press "Update Dataset".

I hope that helps!!

All Answers

Hadi UppalHadi Uppal

Hey Michele, 

I had the same issue and was able to get it resoolved. You need to have the correct fields and ensure that they have the correct label as well.

Field List:
Label | API Name
1) Account Name | AccountId.Name
2) Account Country | AccountId.BillingCountry
3) Owner | OwnerId.Name
4) Stage (formed from Bucket Cluster)
5) Account City | AccountId.BillingCity
6) Account State/Province | AccountId.BillingState
7) Close Date | CloseDate
8) Name | Name
9) Type | Type
10)  Account Type | AccountId.Type
11) Lead Source | LeadSource
12) Industry | AccountId.Industry
13) Owner Title | OwnerId.Title
14) Created Date | CreatedDate
15) USD Amount | USDAmount

If you still have an issue, add in the OwnerId field. The instructions say to remove it but I had it just in case. Ensure these columns are available in the preview and selected when you press "Update Dataset".

I hope that helps!!

This was selected as the best answer
Jonathan AllenbyJonathan Allenby
Thank you so much Hadi, the other thread offering solutions didn't include this list. I had Type as "Opportunity Type" and this saved be from having to start again from scratch,
Evaldas ZarankaEvaldas Zaranka

Thanks Hadi!!! I created a case and asked trailhead team to update the challenge as many of us facing the same issue because of incorrect information provided. 

Current version:

Drop Columns and Change Labels
Your recipe has columns that you don’t need. For example, it’s unlikely that any one would ever want to analyze account IDs. And many columns that you might want to keep have unfriendly names. AccountId.BillingCountry, anyone?

Use the Columns tab for an uncluttered place to drop columns and change labels.

Click the Columns tab. Let's drop some columns from the recipe so they don't appear in the final dataset.
Select the AccountId column, click Drop Columns transformation button, and then click Apply. The column is dropped from the recipe.
Repeat step 2 to drop the following columns
OwnerId
Id
Amount
Rate
Tip: Instead of creating a separate Drop Columns transformation for each column, use Cmd+click for MacOS or Ctrl+click for Windows to select multiple columns, and then apply a single Drop Columns transformation.
Now let's clean up some column labels.
Select the AccountId.Name column, click Edit Attributes transformation button, change the label to Account Name, and click Apply. Change the column label in the left pane of the Edit Attributes transformation settings.
Repeat step 4 to change these column labels as well.
AccountId.BillingCountry to Account Country
OwnerId.Name to Owner
AccountId.BillingCity to Account City
AccountId.BillingState to Account State/Province
CloseDate to Close Date
AccountId.Type to Account Type
LeadSource to Lead Source
AccountId.Industry to Industry
OwnerId.Title to Owner Title
CreatedDate to Created Date
StageName to Stage
Click Save twice to save our latest recipe changes.
At the top of Data Prep, click the Preview tab.
Ahh, that’s better. Your data preparation tasks are done. All that’s left to do is specify where to write the results and then run the recipe to write the results to the specified target.

---------

How it should be:

Drop Columns and Change Labels
Your recipe has columns that you don’t need. For example, it’s unlikely that any one would ever want to analyze account IDs. And many columns that you might want to keep have unfriendly names. AccountId.BillingCountry, anyone?

Use the Columns tab for an uncluttered place to drop columns and change labels.

Click the Columns tab. Let's drop some columns from the recipe so they don't appear in the final dataset.
Select the AccountId column, click Drop Columns transformation button, and then click Apply. The column is dropped from the recipe.
Repeat step 2 to drop the following columns
OwnerId
Id
Rate
Tip: Instead of creating a separate Drop Columns transformation for each column, use Cmd+click for MacOS or Ctrl+click for Windows to select multiple columns, and then apply a single Drop Columns transformation.
Now let's clean up some column labels.
Select the AccountId.Name column, click Edit Attributes transformation button, change the label to Account Name, and click Apply. Change the column label in the left pane of the Edit Attributes transformation settings.
Repeat step 4 to change these column labels as well.
AccountId.BillingCountry to Account Country
OwnerId.Name to Owner
AccountId.BillingCity to Account City
AccountId.BillingState to Account State/Province
CloseDate to Close Date
AccountId.Type to Account Type
LeadSource to Lead Source
AccountId.Industry to Industry
OwnerId.Title to Owner Title
CreatedDate to Created Date
StageName to Stage
Amount to USD Amount
Click Save twice to save our latest recipe changes.
At the top of Data Prep, click the Preview tab.
Ahh, that’s better. Your data preparation tasks are done. All that’s left to do is specify where to write the results and then run the recipe to write the results to the specified target.

Mark JonesMark Jones
Thank you for your answer Hadi ... your answer seemed to work for me. I ended up recreating the recipe and the dataset and left the Opportunity ID in the list of fields in the transform part of the task and it worked. Glad that's done now. This was surprisngly quite a dificult unit, despite doing everything the guidance told me to.