Skip to main content

#Save0 discussing

Hi, I'm new to Salesforce surveys and I have created my first survey but when I tried to save it I received the error: We can't save your survey because of an error: null

Can anyone shine some light on where I have gone wrong for me??

0/9000

Hi - I asked about data blending last week but got no response so I'll be more specific in hopes of getting help, like, today if possible...

 

Client needs a dashboard created with one CSV file and one TXT file as the datasources.   I can't get any actual data connections for this one, sadly, and I don't even have the option to put the content into a db.

 

Problem is, trying the bizarre **** known as Data Blending yields nothing at all.

 

I just need to join them, like a pair of tables, on 4 fields or so.  Full outer join with all fields from both tables showing in the resultant view, even if they have to be Null because of a lack of matching in the opposite file.

 

e.g. File 1 has columns A B C D E, file 2 has b c d F G H I.

 

After joining, I would have A [Bb] [Cc] [Dd] E F G H I.

 

That's all I want to do, but I can't even find the option to add a second datasource with a join, the way I would in a database connection.

 

Thanks for any help you can provide.

18 answers
  1. Jul 25, 2017, 4:56 PM

    Hi Dave,

     

    Well, Here are the simple steps I followed to connect two data files, one CSV to another text file. It worked beautifully.

     

    Hi Dave, Well, Here are the simple steps I followed to connect two data files, one CSV to another text file. It worked beautifully.

     

    Step 1: connect using Text file:

    pastedImage_4.png

    pastedImage_5.png

    Step 2: To add the CSV, you have two options:

    Option 1: In case the CSV is at the same location as the Text file, Simply drag the CSV file and join.

    pastedImage_7.png

     

    Option 2: In case the CSV is at other file location, Click on add button and add another data source through a Text file. Locate the CSV and drag it to the joining area and Click on full outer join or whatever kind of join you want.

    pastedImage_8.png.

     

    Let me know in case you need some more help.

     

    Abhi.

0/9000