Delete empty entries in repeated table

[Jürgen Dietze]

Hello,
could you please help me with the following problem:

In an infopath-formular a user can add several entries from a dropdownlist
in a repeted table.
When I publish the formular to a sharepointsite i use the merge-function to
save the entries. This is what can happen:

Choice1
Choice2
"EMPTY"
Choice3
"EMPTY"

and so on. I can not use the "must not be kept empty"-checkbox for this
field for it is possible to choose nothing.

Later on in a workflow other persons have to approve the choices. They get
entries with no text to approve.

This is my question:
Is it possible (without programm code) to automatically delete these
unneccessary entries before sending these data to a data connection?

Hope you can help me!
Jürgen

 

[Shiva (GGK Tech)]

Hello,

We can add the filter while taking the values form secondary data connection.
Filter should be like below,

Field1 is not blank

 

[Jürgen Dietze]

Hello Shiva,
thank you for your help, although it does not work as I wanted to. I will
describe my problem in another way:

Our employees can register to several types ocf courses (Languages,
Computer,...)
For each type of course I have a repeating table in my form.

Sending the data via secondary dataconnection to sharepoint, the result is
the following:
- one xml-file
one column for each type of course that contains all choosen courses,
separated by a chr(10)

Course1 chr(10) Course2 CHR(10) Course3

In the next step, when the "boss" decides if the employees may take part in
the courses I'm doing the same with a sending connection. I get a second
column that contains the decision, (1 for pass, 0 for failed):

1 Chr(10) 0 Chr(10) 1

To handle these data for example in Excel I have to write a macro that
separates these strings and creates single rows for each course. Much better
would be, to get the data to a sharepoint-list in this way:

Employee1 Course1 Decision1
Employee1 Course2 Decision2
Employee2 Course1 Decision1
Employee2 Course2 Decision2

Could you give me a hint, how to do this?

Jürgen

 

[Shiva (GGK Tech)]

Hello,

In your first question and next explanation of your problem is different
otherwise I might be understand in different way.
In your case you have to add one more field using concat option you have to
set that field value as per your requirement. Then you can promote newly
added field to SharePoint to see the data for those three fields’ data in one
field.